package mybatis;

import com.alibaba.druid.sql.PagerUtils;
import com.alibaba.druid.util.JdbcConstants;

public class Te {
	public static void main(String[] args) {
		String sql = "SELECT * from user";
		String result = PagerUtils.count(sql, JdbcConstants.MYSQL);
		System.out.println(result);
		String result2 = PagerUtils.limit(sql, JdbcConstants.MYSQL, 20, 10);
		System.out.println(result2);
		System.out.println(PagerUtils.limit(sql, JdbcConstants.ORACLE, 20, 10));
		System.out.println(PagerUtils.limit(sql, JdbcConstants.SQL_SERVER, 20, 10));
		System.out.println(PagerUtils.limit(sql, JdbcConstants.DB2, 20, 10));
	}
}
